package com.topisv.tms.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.ViewLogisticsCompanyNO;


public interface ViewLogisticsCompanyDao extends PagingAndSortingRepository<ViewLogisticsCompanyNO, Long>,JpaSpecificationExecutor<ViewLogisticsCompanyNO>{
	
	@Query("select v from ViewLogisticsCompanyNO v where v.unuse<=1500")
	public List<ViewLogisticsCompanyNO> findMailNo();
}
